'\" t
.\"     Title: \fBmysqlrplms\fR
.\"    Author: [FIXME: author] [see http://docbook.sf.net/el/author]
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
.\"      Date: 01/14/2017
.\"    Manual: MySQL Utilities
.\"    Source: MySQL 1.6.4
.\"  Language: English
.\"
.TH "\FBMYSQLRPLMS\FR" "1" "01/14/2017" "MySQL 1\&.6\&.4" "MySQL Utilities"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
mysqlrplms \- Set Up and Start Replication from a Slave to Multiple Masters
.SH "SYNOPSIS"
.HP \w'\fBmysqlrplms\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
\fBmysqlrplms [\fR\fB\fIoptions\fR\fR\fB]\fR
.SH "DESCRIPTION"
.PP
This utility permits a user to start replication from multiple master servers (also called multi\-source replication) to a single slave\&. The user provides login information for the slave and each of the masters\&.
.PP
The utility reports conditions where the storage engines on the masters and the slave differ\&. It also reports a warning if the InnoDB storage engine differs on the master and slave\&. For InnoDB to be the same, both servers must be running the same "type" of InnoDB (built\-in or the InnoDB Plugin), and InnoDB on both servers must have the same major and minor version numbers and enabled state\&. By default, the utility issues warnings for mismatches between the sets of storage engines, the default storage engine, and the InnoDB storage engine\&.
.PP
The
\fB\-vv\fR
option displays any discrepancies between the storage engines and InnoDB values\&.
.PP
A round\-robin scheduling is used to setup replication among the masters and slave\&.
.PP
The mysqlrplms utility follows these assumptions:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
All servers must have GTIDs enabled\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
There are no conflicts between transactions from different masters\&. For example, there are no updates to the same object from multiple masters\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Replication is asynchronous\&.
.RE
OPTIONS.PP
\fBmysqlrplms\fR
accepts the following command\-line options:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-daemon=\fIcommand\fR
.sp
Run as a daemon\&. The
\fIcommand\fR
can be
start
(start daemon),
stop
(stop daemon),
restart
(stop then start the daemon) or
nodetach
(start but do not detach the process)\&. This option is only available for POSIX systems\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-format=\fIformat\fR, \-f
\fIformat\fR
.sp
Display the replication health output in either grid (default), tab, csv, or vertical format\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-help
.sp
Display a help message and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-interval=\fIseconds\fR, \-i
\fIseconds\fR
.sp
Interval in seconds for reporting health\&. Default = 15 seconds\&. Minimum is 5 seconds\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-license
.sp
Display license information and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-log=\fIlog_file\fR
.sp
Specify a log file to use for logging messages
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-log\-age=\fIdays\fR
.sp
Specify maximum age of log entries in days\&. Entries older than this are purged on startup\&. Default = 7 days\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-masters=\fImaster connections\fR
.sp
Connection information for master servers\&. List multiple masters in comma\-separated list\&.
.sp
To connect to a server, it is necessary to specify connection parameters such as the user name, host name, password, and either a port or socket\&. MySQL Utilities provides a number of ways to supply this information\&. All of the methods require specifying your choice via a command\-line option such as \-\-server, \-\-master, \-\-slave, etc\&. The methods include the following in order of most secure to least secure\&.
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Use login\-paths from your
\&.mylogin\&.cnf
file (encrypted, not visible)\&. Example :
\fIlogin\-path\fR[:\fIport\fR][:\fIsocket\fR]
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Use a configuration file (unencrypted, not visible) Note: available in release\-1\&.5\&.0\&. Example :
\fIconfiguration\-file\-path\fR[:\fIsection\fR]
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Specify the data on the command\-line (unencrypted, visible)\&. Example :
\fIuser\fR[:\fIpasswd\fR]@\fIhost\fR[:\fIport\fR][:\fIsocket\fR]
.RE
.sp
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-report\-values=\fIreport_values\fR
.sp
Report values used in mysqlrplms\&. It can be health, gtid or uuid\&. Multiple values can be used separated by commas\&.
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
health
.sp
Display the replication health of the topology\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
gtid
.sp
Display the master\*(Aqs list of executed GTIDs, contents of the GTID variables;
@@GLOBAL\&.GTID_EXECUTED,
@@GLOBAL\&.GTID_PURGED
and
@@GLOBAL\&.GTID_OWNED\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
uuid
.sp
Display universally unique identifiers (UUIDs) for all servers\&.
.RE
.sp
Default = health\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-rpl\-user=\fIreplication_user\fR
.sp
The user and password for the replication user, in the format:
\fIuser\fR[:\fIpassword\fR] or
\fIlogin\-path\fR\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-slave=\fIslave\fR
.sp
Connection information for the slave server\&. You may specify only one slave for this option\&.
.sp
To connect to a server, it is necessary to specify connection parameters such as the user name, host name, password, and either a port or socket\&. MySQL Utilities provides a number of ways to supply this information\&. All of the methods require specifying your choice via a command\-line option such as \-\-server, \-\-master, \-\-slave, etc\&. The methods include the following in order of most secure to least secure\&.
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Use login\-paths from your
\&.mylogin\&.cnf
file (encrypted, not visible)\&. Example :
\fIlogin\-path\fR[:\fIport\fR][:\fIsocket\fR]
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Use a configuration file (unencrypted, not visible) Note: available in release\-1\&.5\&.0\&. Example :
\fIconfiguration\-file\-path\fR[:\fIsection\fR]
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
Specify the data on the command\-line (unencrypted, visible)\&. Example :
\fIuser\fR[:\fIpasswd\fR]@\fIhost\fR[:\fIport\fR][:\fIsocket\fR]
.RE
.sp
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-ssl\-ca
.sp
The path to a file that contains a list of trusted SSL CAs\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-ssl\-cert
.sp
The name of the SSL certificate file to use for establishing a secure connection\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-ssl\-key
.sp
The name of the SSL key file to use for establishing a secure connection\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-ssl
.sp
Specifies if the server connection requires use of SSL\&. If an encrypted connection cannot be established, the connection attempt fails\&. Default setting is 0 (SSL not required)\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-start\-from\-beginning, \-b
.sp
Start replication at the beginning of events logged in the master binary log\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-switchover\-interval=\fIseconds\fR
.sp
Interval in seconds for switching masters\&. Default = 60 seconds\&. Minimum is 30 seconds\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-pidfile=\fIpidfile\fR
.sp
Pidfile for running mysqlrplms as a daemon\&. This file contains the PID (process identifier), that uniquely identify a process\&. It is needed to identify and control the process forked by mysqlrplms\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-verbose, \-v
.sp
Specify how much information to display\&. Use this option multiple times to increase the amount of information\&. For example,
\fB\-v\fR
= verbose,
\fB\-vv\fR
= more verbose,
\fB\-vvv\fR
= debug\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-version
.sp
Display version information and exit\&.
.RE
NOTES.PP
The login user for the master servers must have the appropriate permissions to grant access to all databases, and have the ability to create user accounts\&. For example, the user accounts used to connect to each of the masters must have the
\fBWITH GRANT OPTION\fR
privilege\&.
.PP
The server IDs on the masters and slave must be nonzero and unique\&. The utility reports an error if the server ID is 0 on either server or the same on the masters and slave\&. Set these values before starting this utility\&.
.PP
Mixing IP and hostnames is not recommended\&. The replication\-specific utilities attempts to compare hostnames and IP addresses as aliases for checking slave connectivity to the master\&. However, if your installation does not support reverse name lookup, the comparison could fail\&. Without the ability to do a reverse name lookup, the replication utilities could report a false negative that the slave is (not) connected to the master\&.
.PP
The path to the MySQL client tools should be included in the
PATH
environment variable in order to use the authentication mechanism with login\-paths\&. This permits the utility to use the
\fBmy_print_defaults\fR
tools which is required to read the login\-path values from the login configuration file (\&.mylogin\&.cnf)\&.
.PP
Due to a known server issue, there are some limitations with the use of temporary tables with multi\-source replication\&. In order to avoid problems, we recommend the execution of all statements for a temporary table in a single transaction\&. See
\m[blue]\fBReplication and Temporary Tables\fR\m[]\&\s-2\u[1]\d\s+2, for more information\&.
EXAMPLES.PP
To set up multi\-source replication among two masters and a slave, running on different ports of the same host using the default settings, use this command:
.sp
.if n \{\
.RS 4
.\}
.nf
shell> \fBmysqlrplms \-\-slave=root:root@localhost:3306 \e\fR
       \fB\-\-masters=root:root@localhost:3307,root:root@localhost:3308\fR
# Starting multi\-source replication\&.\&.\&.
# Press CTRL+C to quit\&.
# Switching to master \*(Aqlocalhost:3307\*(Aq\&.
# master on localhost: \&.\&.\&. connected\&.
# slave on localhost: \&.\&.\&. connected\&.
#
# Current Master Information:
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| Binary Log File   | Position  | Binlog_Do_DB  | Binlog_Ignore_DB  |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| clone\-bin\&.000001  | 594       | N/A           | N/A               |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
# GTID Executed Set: 00a4e027\-a83a\-11e3\-8bd6\-28d244017f26:1\-2
#
# Health Status:
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
| host       | port  | role    | state  | gtid_mode  | health  |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
| localhost  | 3307  | MASTER  | UP     | ON         | OK      |
| localhost  | 3306  | SLAVE   | UP     | ON         | OK      |
| localhost  | 3308  | MASTER  | UP     | ON         | OK      |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
#
(\&.\&.\&.)
.fi
.if n \{\
.RE
.\}
.PP
The following command uses \-\-report\-values to report health, GTID and UUID status:
.sp
.if n \{\
.RS 4
.\}
.nf
shell> \fBmysqlrplms \-\-slave=root:root@localhost:3306 \e\fR
       \fB\-\-masters=root:root@localhost:3307,root:root@localhost:3308\en\fR
       \fB\-\-report\-values=health,gtid,uuid\fR
# Starting multi\-source replication\&.\&.\&.
# Press CTRL+C to quit\&.
# Switching to master \*(Aqlocalhost:3307\*(Aq\&.
# master on localhost: \&.\&.\&. connected\&.
# slave on localhost: \&.\&.\&. connected\&.
#
# Current Master Information:
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| Binary Log File   | Position  | Binlog_Do_DB  | Binlog_Ignore_DB  |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| clone\-bin\&.000001  | 594       | N/A           | N/A               |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
# GTID Executed Set: 00a4e027\-a83a\-11e3\-8bd6\-28d244017f26:1\-2
#
# Health Status:
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
| host       | port  | role    | state  | gtid_mode  | health  |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
| localhost  | 3307  | MASTER  | UP     | ON         | OK      |
| localhost  | 3306  | SLAVE   | UP     | ON         | OK      |
| localhost  | 3308  | MASTER  | UP     | ON         | OK      |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+
#
# GTID Status \- Transactions executed on the servers:
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| host       | port  | role    | gtid                                      |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| localhost  | 3307  | MASTER  | 00a4e027\-a83a\-11e3\-8bd6\-28d244017f26:1\-2  |
| localhost  | 3306  | SLAVE   | 00a4e027\-a83a\-11e3\-8bd6\-28d244017f26:1\-2  |
| localhost  | 3306  | SLAVE   | faf0874f\-a839\-11e3\-8bd6\-28d244017f26:1    |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
#
# UUID Status:
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| host       | port  | role    | uuid                                  |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
| localhost  | 3307  | MASTER  | 00a4e027\-a83a\-11e3\-8bd6\-28d244017f26  |
| localhost  | 3306  | SLAVE   | faf0874f\-a839\-11e3\-8bd6\-28d244017f26  |
+\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
#
(\&.\&.\&.)
.fi
.if n \{\
.RE
.\}
.PP
Start multi\-source replication running as a daemon (POSIX only):
.sp
.if n \{\
.RS 4
.\}
.nf
shell> \fBmysqlrplms \-\-slave=root:root@localhost:3306 \e\fR
       \fB\-\-masters=root:root@localhost:3307,root:root@localhost:3308 \e\fR
       \fB\-\-log=rplms_daemon\&.log \-\-pidfile=rplms_daemon\&.pid \-\-daemon=start\fR
.fi
.if n \{\
.RE
.\}
.PP
Restart multi\-source replication running as a daemon:
.sp
.if n \{\
.RS 4
.\}
.nf
shell> \fBmysqlrplms \-\-slave=root:root@localhost:3306 \e\fR
       \fB\-\-masters=root:root@localhost:3307,root:root@localhost:3308 \e\fR
       \fB\-\-log=rplms_daemon\&.log \-\-pidfile=rplms_daemon\&.pid \-\-daemon=restart\fR
.fi
.if n \{\
.RE
.\}
.PP
Stop multi\-source replication running as a daemon:
.sp
.if n \{\
.RS 4
.\}
.nf
shell> \fBmysqlrplms \-\-slave=root:root@localhost:3306 \e\fR
       \fB\-\-masters=root:root@localhost:3307,root:root@localhost:3308 \e\fR
       \fB\-\-log=rplms_daemon\&.log \-\-pidfile=rplms_daemon\&.pid \-\-daemon=stop\fR
.fi
.if n \{\
.RE
.\}
.sp
RECOMMENDATIONS.PP
You should set
read_only=1
in the
my\&.cnf
file for the slave to ensure that no accidental data changes, such as
\fBINSERT\fR,
\fBDELETE\fR,
\fBUPDATE\fR, and so forth, are permitted on the slave other than those produced by events read from the master\&.
PERMISSIONS REQUIRED.PP
The users on the masters need the following privileges: SELECT and INSERT privileges on mysql database, REPLICATION SLAVE, REPLICATION CLIENT and GRANT OPTION\&. The slave users need the SUPER privilege\&. The rpl user, used as the argument for the
\fB\-\-rpl\-user\fR
option, is either created automatically or if it exists, it needs the REPLICATION SLAVE privilege\&.
.SH "COPYRIGHT"
.br
.PP
Copyright \(co 2006, 2017, Oracle and/or its affiliates. All rights reserved.
.PP
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
.PP
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
.PP
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
.sp
.SH "NOTES"
.IP " 1." 4
Replication and Temporary Tables
.RS 4
\%http://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
.RE
.SH "SEE ALSO"
For more information, please refer to the MySQL Utilities and Fabric
documentation, which is available online at
http://dev.mysql.com/doc/index-utils-fabric.html
.SH AUTHOR
Oracle Corporation (http://dev.mysql.com/).
